求一个JDBC连接Mysql一部分的代码! String sql="select *from dept where id=?";stmt.executeUpdate(sql);然后?这个值怎么传啊?求一个例子!jdbcmysqlsql 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 这个是我当时的的笔记你看看吧import java.sql.Connection;import java.sql.Driver;import java.sql.DriverManager;import java.sql.ResultSet;import java.sql.Statement;import java.util.Properties;public class FirstJDBCTest { public static void main(String[] args) { Connection conn = null;// 建立连接 Statement stm = null; ResultSet rs = null; try { // 1.注册驱动 //1.1类加载 //Class.forName("oracle.jdbc.driver.OracleDriver"); //1.2初始化Driver Driver dri = new oracle.jdbc.driver.OracleDriver(); DriverManager.registerDriver(dri); //1.3向虚拟机传参数 /* * java-Djdbc.driver=oracle.jdbc.driver.OracleDriver */ // 2.创建驱动 /* * getConnection(1,2,3) 1.将要连接的数据库实例 2.用户名 3.密码 */ //2.1 /*conn = DriverManager.getConnection( "jdbc:oracle:thin:@127.0.0.1:1521:XE", "system", "oracle1"); */ //2.2 Driver.connect() Properties pros=new Properties(); pros.setProperty("user", "system"); pros.setProperty("password", "oracle1"); conn=dri.connect("jdbc:oracle:thin:@127.0.0.1:1521:XE", pros); // System.out.println(conn); // 3.创建statement对象 stm = conn.createStatement(); String sql = "select * from account_tbl"; // 4.执行sql语句 rs = stm.executeQuery(sql); // 5.处理结果集 while (rs.next()) { System.out.println("编号:"+rs.getInt(1)); System.out.println("卡号:"+rs.getString(2)); System.out.println("姓名:"+rs.getString(3)); System.out.println("证件:"+rs.getString(4)); System.out.println("余额:"+rs.getDouble(5)); System.out.println("开户日期:"+rs.getDate(6)); System.out.println("最后修改:"+rs.getDate(7)); System.out.println("-------------------------"); } } catch (Exception e) { // TODO Auto-generated catch block e.printStackTrace(); } finally { try { if (rs != null) { rs.close(); } if(stm!=null){ stm.close(); } if(conn!=null){ conn.close(); } } catch (Exception e) { // TODO Auto-generated catch block e.printStackTrace(); } } }} String sql="select *from dept where id=?";Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/myDB","root","123456");PreparedStatement ps = conn.prepareStatement(sql);ps.setInt(1,454);ResultSet rs = ps.executeQuery(); import java.sql.*;public class TestMysqlConnection { public static void main(String[] args) { Connection conn=null; Statement stmt = null; ResultSet rs = null; try { Class.forName("com.mysql.jdbc.Driver"); conn = DriverManager.getConnection("jdbc:mysql://localhost/mydate?" + "user=root&password=0210"); stmt = conn.createStatement(); rs = stmt.executeQuery("select * from dept"); while(rs.next()){ System.out.println(rs.getString("deptno")); } }catch(ClassNotFoundException e){ e.printStackTrace(); }catch(SQLException ex){ System.out.println("SQLException: " + ex.getMessage()); System.out.println("SQLState: " + ex.getSQLState()); System.out.println("VendorError: " + ex.getErrorCode()); } finally { try { if(rs != null) { rs.close(); rs = null; } if(stmt != null) { stmt.close(); stmt = null; } if(conn != null) { conn.close(); conn = null; } } catch (SQLException e) { e.printStackTrace(); } } }} 以前写的 标题:经典java、.net、php、网页平面视频教程DVD免费申领内容:改变中国it教育是传智播客毕生为之奋斗的目标,为了让我们的教程更大范围地普及到广大学子身上,传智播客投入了百万元刻录了几十万张java、.net、php、网页平面设计学习光盘,现在免费赠送给广大学子。相信有了我们的教程,您不再感叹编程入门难,相信有了我们的教程,您的人生将从此改变。免费领取:http://www.itcast.cn/subject/wrfq/index.html?from=jz PreparedStatement stmt = conn.prepareStatement(sql);stmt.setString(0, "xxx");用PreparedStatement 可以设置参数 如果不是预处理你可以直接传啊,String sql = "select * from dept where id = "+id; rs = stmt.careateQuery(sql);如果预处理: String sql="select *from dept where id=?";Connection conn = DriverManager.getConnectio("jdbc:mysql://localhost:3306/myDB","root","123");PreparedStatement ps = conn.prepareStatement(sql);ps.setInt(1,id);ResultSet rs = ps.executeQuery(); java中如何将字符串的编码从utf-8转换成gbk而且不会产生乱码(超过字符集的可以是?) 跪求一SQL查询语句 weblogic jdbc错误 iis+tomcat还是apache+tomcat know 哪位大侠知道用java发送dtmf(rfc2833) rtp消息怎么做 求图片上传的源码 ssh实现无限级菜单 怎么把一个整型专成字符型?? 带有ejb的工程使用cvs检入后检出为什么就剩下了几个类文件? java读取oracle al32utf8 乱码 eclippse+tomcat6.0的配置网上怎么没有啊!
import java.sql.Driver;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.Properties;public class FirstJDBCTest { public static void main(String[] args) {
Connection conn = null;// 建立连接
Statement stm = null;
ResultSet rs = null; try {
// 1.注册驱动
//1.1类加载
//Class.forName("oracle.jdbc.driver.OracleDriver");
//1.2初始化Driver
Driver dri = new oracle.jdbc.driver.OracleDriver();
DriverManager.registerDriver(dri);
//1.3向虚拟机传参数
/*
* java-Djdbc.driver=oracle.jdbc.driver.OracleDriver
*/
// 2.创建驱动
/*
* getConnection(1,2,3) 1.将要连接的数据库实例 2.用户名 3.密码
*/
//2.1
/*conn = DriverManager.getConnection(
"jdbc:oracle:thin:@127.0.0.1:1521:XE", "system", "oracle1");
*/
//2.2 Driver.connect()
Properties pros=new Properties();
pros.setProperty("user", "system");
pros.setProperty("password", "oracle1");
conn=dri.connect("jdbc:oracle:thin:@127.0.0.1:1521:XE", pros);
// System.out.println(conn); // 3.创建statement对象
stm = conn.createStatement();
String sql = "select * from account_tbl";
// 4.执行sql语句
rs = stm.executeQuery(sql); // 5.处理结果集 while (rs.next()) {
System.out.println("编号:"+rs.getInt(1));
System.out.println("卡号:"+rs.getString(2));
System.out.println("姓名:"+rs.getString(3));
System.out.println("证件:"+rs.getString(4));
System.out.println("余额:"+rs.getDouble(5));
System.out.println("开户日期:"+rs.getDate(6));
System.out.println("最后修改:"+rs.getDate(7));
System.out.println("-------------------------");
}
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
} finally { try {
if (rs != null) {
rs.close();
}
if(stm!=null){
stm.close();
}
if(conn!=null){
conn.close();
}
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace(); }
}
}
}
Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/myDB","root","123456");
PreparedStatement ps = conn.prepareStatement(sql);
ps.setInt(1,454);
ResultSet rs = ps.executeQuery();
public static void main(String[] args) {
Connection conn=null;
Statement stmt = null;
ResultSet rs = null;
try {
Class.forName("com.mysql.jdbc.Driver");
conn = DriverManager.getConnection("jdbc:mysql://localhost/mydate?" + "user=root&password=0210");
stmt = conn.createStatement();
rs = stmt.executeQuery("select * from dept");
while(rs.next()){
System.out.println(rs.getString("deptno"));
}
}catch(ClassNotFoundException e){
e.printStackTrace();
}catch(SQLException ex){
System.out.println("SQLException: " + ex.getMessage());
System.out.println("SQLState: " + ex.getSQLState());
System.out.println("VendorError: " + ex.getErrorCode());
}
finally {
try {
if(rs != null) {
rs.close();
rs = null;
}
if(stmt != null) {
stmt.close();
stmt = null;
}
if(conn != null) {
conn.close();
conn = null;
}
} catch (SQLException e) {
e.printStackTrace();
}
}
}
}
以前写的
内容:改变中国it教育是传智播客毕生为之奋斗的目标,为了让我们的教程更大范围地普及到广大学子身上,传智播客投入了百万元刻录了几十万张java、.net、php、网页平面设计学习光盘,现在免费赠送给广大学子。相信有了我们的教程,您不再感叹编程入门难,相信有了我们的教程,您的人生将从此改变。免费领取:http://www.itcast.cn/subject/wrfq/index.html?from=jz
stmt.setString(0, "xxx");
用PreparedStatement 可以设置参数
如果预处理:
String sql="select *from dept where id=?";
Connection conn = DriverManager.getConnectio("jdbc:mysql://localhost:3306/myDB","root","123");
PreparedStatement ps = conn.prepareStatement(sql);
ps.setInt(1,id);
ResultSet rs = ps.executeQuery();