java jtds连接数据库

public void sqlTest throws SQLException
    {
        
try {
            Class.forName(
"net.sourceforge.jtds.jdbc.Driver");
            Connection con 
= DriverManager.getConnection("jdbc:jtds:sqlserver://localhost:1433/pubs","sa","sa");            
            Statement st 
= con.createStatement();            
            ResultSet rs 
= st.executeQuery("SELECT * FROM table1");
            
while(rs.next())
            {
                String a 
= rs.getString(0);        
                
            }
        } 
catch (ClassNotFoundException e) {
            
// TODO Auto-generated catch block
            e.printStackTrace();
        }    
        
    }

posted on 2009-07-01 11:46  seaven  阅读(2205)  评论(0)    收藏  举报

导航