求一个JDBC连接Mysql一部分的代码！

[飞羽解]

String sql="select *from dept where id=?";
stmt.executeUpdate(sql);
然后？这个值怎么传啊？求一个例子！

[飞羽解]

顶

[飞羽解]

是stmt.executeQuery眼花了

[qqspringlove1]

这个是我当时的的笔记你看看吧 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(); } } } }

[wind_elf]

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();

[qq_wwwhj]

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();
			}
		}
    }
}
    

以前写的

[一名dotaer]

标题：经典java、.net、php、网页平面视频教程DVD免费申领 内容：改变中国it教育是传智播客毕生为之奋斗的目标，为了让我们的教程更大范围地普及到广大学子身上，传智播客投入了百万元刻录了几十万张java、.net、php、网页平面设计学习光盘，现在免费赠送给广大学子。相信有了我们的教程，您不再感叹编程入门难，相信有了我们的教程，您的人生将从此改变。免费领取：http://www.itcast.cn/subject/wrfq/index.html?from=jz

[cjf2773]

PreparedStatement stmt = conn.prepareStatement(sql); stmt.setString(0, "xxx"); 用PreparedStatement 可以设置参数

[二师兄2不2]

如果不是预处理你可以直接传啊，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();