mssql2005 JDBC

package com.wangguan;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;


public class TestJdbc {
    

    
public static void main(String[] args) {
        Connection con 
= null;
        Statement  sta 
= null;
        
        
try {
            Class.forName(
"com.microsoft.sqlserver.jdbc.SQLServerDriver");
            String url 
= "jdbc:sqlserver://127.0.1:1433;databaseName=studentManager";
            con 
= DriverManager.getConnection(url, "sa""wangguan");
            sta 
= con.createStatement();
            String sql 
= "insert into student" + 
                         
"    (stuName, address, stuTel, age, groupId)" +
                         
"values"+
                         
"    ('王冠','黑龙江','13723984599',23,2)";
            
int row = sta.executeUpdate(sql);
            
if(row == 0) {
                System.out.println();
            } 
else {
                System.out.println();
            }
            sta.close();
            con.close();
        } 
catch (ClassNotFoundException e) {
            e.printStackTrace();
        } 
catch (SQLException e) {
            e.printStackTrace();
        } 
finally {
            
try {
                
if(sta != null) {
                    sta.close();
                    sta 
= null;
                }
                
if(con != null) {
                    con.close();
                    con 
= null;
                }
            } 
catch (SQLException e) {
                e.printStackTrace();
            }
        }
    }

}

posted on 2011-04-22 22:07  段天狼  阅读(376)  评论(0编辑  收藏  举报

导航