如何用java调用数据库中的数据?
我的Eclipse已经连接上了sql server 2000,我想请问下高手如何调用数据库中的信息,比如我的数据库中的表student中有name,sex,telephone,number,class等属性,请高手能帮忙!最好能写下代码!
[解决办法]
得找个jdbc驱动包,lz自己上网找下吧
一般步骤:
1.加载驱动
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
2.获得连接
Connection conn = DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433; DatabaseName=pubs", usr, password);
3.Statement stat = conn.creatStatement();
4.获得结果集与执行sql语句: ResultSet rs = stat.executeUpdate(String sql)
stat.executeQuery(String sql)
5.ResultSet 中有很多方法可以进行对数据库的操作,自己查一下吧
6关闭
[解决办法]
这是我的连接数据库是用到的类,你只要把驱动和连接方式换成sql server 2000的就可以用。
package DB;import java.sql.*;public class DataBaseConnection { private final String DBDRIVER = "com.mysql.jdbc.Driver"; private final String DBURL = "jdbc:mysql://127.0.0.1:3307/courseselection?useUnicode=true&characterEncoding=gb2312"; private final String DBUSER = "root"; private final String DBPASSWORD = "root"; private Connection conn = null; public Connection getConn() { try { Class.forName(DBDRIVER).newInstance(); conn = DriverManager.getConnection(DBURL, DBUSER, DBPASSWORD); } catch (Exception e) { System.out.println("数据库连接失败"); } return conn; } public void close() { try { this.conn.close(); } catch (Exception e) { System.out.println("数据库关闭失败!"); } } public ResultSet executeQuery(String sql) { ResultSet rs = null; try { rs = null; Connection conn = this.getConn(); Statement stmt = conn.createStatement(); rs = stmt.executeQuery(sql); } catch (SQLException ex) { System.out.println("执行错误"); ex.printStackTrace(); } return rs; } public boolean executeUpdate(String strSQL) { try { Connection conn = this.getConn(); Statement stmt = conn.createStatement(); stmt.executeUpdate(strSQL); } catch (SQLException ex) { System.err.println("连接数据库失败了,异常为:" + ex.getMessage()); } return true; }}