今天学了web连接数据库。可以分页显示。虽然觉得简单 还是有点难度的
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
Connection con=DriverManager.getConnection("jdbc:sqlserver://127.0.0.1:1433;databasename=bbs","sa","");
1.增加一条记录//增删改都用executeUpdate
String sql="insert into TBL_USER values(?,?,?,?,?)";
PreparedStatement pstmt=con.prepareStatement(sql);
pstmt.setString(1, "张三");
pstmt.setString(2, "123456");
pstmt.setString(3,"1.gif");
pstmt.setString(4, "2001-1-1");
pstmt.setInt(5, 1);
pstmt.executeUpdate();
--------------------------------------------------------------------------------------------------------------
2.查询所有记录
String sql="select * from TBL_USER";
PreparedStatement pstmt=con.prepareStatement(sql);
ResultSet rs=pstmt.executeQuery();
while(rs.next()){
System.out.println(rs.getString("uName")+" "+rs.getString("regTime"));
}
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
Connection con=DriverManager.getConnection("jdbc:sqlserver://127.0.0.1:1433;databasename=bbs","sa","");
1.增加一条记录//增删改都用executeUpdate
String sql="insert into TBL_USER values(?,?,?,?,?)";
PreparedStatement pstmt=con.prepareStatement(sql);
pstmt.setString(1, "张三");
pstmt.setString(2, "123456");
pstmt.setString(3,"1.gif");
pstmt.setString(4, "2001-1-1");
pstmt.setInt(5, 1);
pstmt.executeUpdate();
--------------------------------------------------------------------------------------------------------------
2.查询所有记录
String sql="select * from TBL_USER";
PreparedStatement pstmt=con.prepareStatement(sql);
ResultSet rs=pstmt.executeQuery();
while(rs.next()){
System.out.println(rs.getString("uName")+" "+rs.getString("regTime"));
}