完整java开发中JDBC连接数据库代码和步骤
来源:互联网 发布:装修攻略 知乎 编辑:程序博客网 时间:2024/06/06 01:29
转载:http://www.cnblogs.com/hongten/archive/2011/03/29/1998311.html
实现mysql demo:
package cn.dlstone.TestMysqlDao;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
public class TestMysqlDao {
private static String url = "jdbc:mysql://localhost:3306/test";
private static String user = "root";
private static String password = "123456";
public static void main(String[] args) {
PreparedStatement pst = null;
ResultSet rs = null;
Connection conn = null;
String sql = "select * from user";
try {
//加载mysql的驱动类
Class.forName("com.mysql.jdbc.Driver");
conn = DriverManager.getConnection(url, user, password);
pst = conn.prepareStatement(sql);
rs = pst.executeQuery();
while(rs.next()) {
String name = rs.getString("name");
System.out.println(name);
}
} catch (ClassNotFoundException e) {
System.out.println("找不到驱动程序类,加载驱动失败!");
e.printStackTrace();
} catch (SQLException e) {
System.out.println("数据库连接失败!");
e.printStackTrace();
} finally {
if(rs != null) {
try {
rs.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
if(pst != null) {
try {
pst.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
if(conn != null) {
try {
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
}
}
import java.sql.CallableStatement;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
public class TestDao {
private static String url = "jdbc:sqlserver://localhost:1433;databasename=student";
private static String user = "sa";
private static String password = "123456";
public static void main(String[] args) {
try {
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
Connection conn = DriverManager.getConnection(url, user, password);
CallableStatement c = conn.prepareCall("{call CursorIntoprocedure(?)}");
c.registerOutParameter(1, java.sql.Types.VARCHAR);
c.execute();
System.out.println(c.getString(1));
conn.close();
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
- 完整java开发中JDBC连接数据库代码和步骤
- 完整java开发中JDBC连接数据库代码和步骤
- 完整java开发中JDBC连接数据库代码和步骤
- 完整java开发中JDBC连接数据库代码和步骤
- 完整java开发中JDBC连接数据库代码和步骤
- 完整java开发中JDBC连接数据库代码和步骤
- 完整java开发中JDBC连接数据库代码和步骤
- 完整java开发中JDBC连接数据库代码和步骤
- 完整java开发中JDBC连接数据库代码和步骤
- 完整java开发中JDBC连接数据库代码和步骤
- 完整java开发中JDBC连接数据库代码和步骤
- 完整java开发中JDBC连接数据库代码和步骤
- 完整java开发中JDBC连接数据库代码和步骤
- 完整java开发中JDBC连接数据库代码和步骤
- 完整java开发中JDBC连接数据库代码和步骤
- 完整java开发中JDBC连接数据库代码和步骤
- 完整java开发中JDBC连接数据库代码和步骤
- 完整java开发中JDBC连接数据库代码和步骤
- 231个javascript特效分享(上)
- Codeforces Round #116 (Div. 2, ACM-ICPC Rules)---E. Cubes
- 常用linux命令
- VC之socket套接字编程
- 理解设备对象
- 完整java开发中JDBC连接数据库代码和步骤
- UVA - 12096 The SetStack Computer STL的大集合
- http状态代码含义
- UVA - 11988 Broken Keyboard (a.k.a. Beiju Text)
- Fortinet Single Sign On Stack Overflow
- 【算法】基于优先级的排班算法实现
- 第四周 项目一三角形类的构造函数
- 黑马程序员《集合(下)--Collections与Arrays》
- 24个 HTML5 & CSS3 下拉菜单效果及制作教程