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();
郑重声明:本站内容如果来自互联网及其他传播媒体,其版权均属原媒体及文章作者所有。转载目的在于传递更多信息及用于网络分享,并不代表本站赞同其观点和对其真实性负责,也不构成任何其他建议。