如何在java代码里连接数据库,进行增删改查。先贴一段用来查询数
作者:admin 发布日期: 阅读次数:195
如何在java代码里连接数据库,进行增删改查。先贴一段用来查询数据库的代码实例:
package com.ph; import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.ResultSet; public class Test1 { public static void main(String[]args) { PreparedStatement ps=null; Connection ct=null; ResultSet rs=null; try { //1.加载驱动 Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
//2.得到链接 127.0.0.1:1433 ct=DriverManager.getConnection ("jdbc:sqlserver://127.0.0.1:1433;databaseName=Mytest","sa","123456"); ps=ct.prepareStatement("select * from course"); rs=ps.executeQuery(); while(rs.next()) { String cno=rs.getString(1); String cname=rs.getString(2); String tno=rs.getString(3); System.out.println("cno "+cno+" cname "+cname+" tno "+tno); } }catch(Exception e) { e.printStackTrace(); }finally { try { if(rs != null)rs.close(); if(ps != null)ps.close(); if(ct != null)ct.close(); }catch(Exception e) { e.printStackTrace(); } } } }
本文标签:暂无标签