java sqlserver 2000_java数据库基本操作（sqlserver 2000为例）

一、环境搭建

1、下载对应数据库连接驱动包并引入。

2、如果在web中调用必须在tomcat中也放入对应的驱动包。

3、在jre的lib\ext中也加入对应的驱动包。

二、连接数据库

public static String server = "localhost";//服务器

public static String port = "1433";//端口号

public static String dbname = "testdb";//数据库

public static String user = "sa";//用户名

public static String pwd = "12345";//用户密码

public static Connection createConnection() throws Exception{

Connection conn = null;

String url = "";

try{

Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");

url = "jdbc:sqlserver://" + server + ":" + port + ";DatabaseName=" + dbname;

conn = DriverManager.getConnection(url,user,pwd);

}catch(SQLException sqlEx){

throw sqlEx;

}catch(Exception ex){

throw ex;

}

return conn;

}

三、基本操作

1、插入：

Connection conn = createConnection();

String sql = "insert into tmap (mapserviceid,mapid,mapname) values(?,?,?)";

PreparedStatement pstmt=conn.prepareStatement(sql);

pstmt.setString(1, "1");

pstmt.setString(2, "7");

pstmt.setString(3, "test1");

pstmt.executeUpdate();

pstmt.close();

conn.close();

2、查询

String sql = "select * from tmap";

PreparedStatement pstmt=conn.prepareStatement(sql);

ResultSet rs=pstmt.executeQuery();

while(rs.next()){

System.out.println(rs.getString("mapname"));

}

3、更新

String sql = "update tmap set mapname=? where mapid = ?";

PreparedStatement pstmt=conn.prepareStatement(sql);

pstmt.setString(1, "namename");

pstmt.setString(2, "7");

pstmt.executeUpdate();

4、删除

String sql = "delete tmap where mapid = ?";

PreparedStatement pstmt=conn.prepareStatement(sql);

pstmt.setInt(1, 7);

pstmt.executeUpdate();