代码如下:
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;public class Demo1 { public static Connection getConncetion(){
try {
String driiverClass = "com.mysql.jdbc.Driver";
String url = "jdbc:mysql://127.0.0.1:3306/user_db";
String user = "root";
String password = "root";
Class.forName(driiverClass);
return DriverManager.getConnection(url,user,password);
} catch ( ClassNotFoundException e) {
// 找不到驱动
e.printStackTrace();
} catch ( SQLException e) {
// 创建链接异常
e.printStackTrace();
}
return null;
}
public static void get(){
String sql = " select id,name,brithday from u_stu where id = 2 ";
PreparedStatement ps= null;
Connection conn = getConncetion();
ResultSet rs = null;
try {
ps = conn.prepareStatement(sql);
// ps.setInt(1, 2);
rs = ps.executeQuery();
while (rs.next()){
System.out.println(rs.getInt("id" + "\t"));
System.out.println(rs.getString("name"+ "\t"));
// System.out.println(rs.getDate("birthday"+ "\t"));
}
rs.close();
ps.close();
}catch (SQLException e) {
e.printStackTrace();
}finally{
try {if(conn!=null){conn.close();} }catch (SQLException e) {e.printStackTrace();}
}
}
public static void main(String[] args) {
get();
}
}运行了之后就报 rs = ps.executeQuery();有错。我个人认为是因为是这行的原因:System.out.println(rs.getDate("birthday"+ "\t"));
因为那个getDate()可能不是我想要的getDate()!清师傅们帮忙解决一下,谢谢了!!!求帮助有关jdbc中getDate的问题JDBC
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;public class Demo1 { public static Connection getConncetion(){
try {
String driiverClass = "com.mysql.jdbc.Driver";
String url = "jdbc:mysql://127.0.0.1:3306/user_db";
String user = "root";
String password = "root";
Class.forName(driiverClass);
return DriverManager.getConnection(url,user,password);
} catch ( ClassNotFoundException e) {
// 找不到驱动
e.printStackTrace();
} catch ( SQLException e) {
// 创建链接异常
e.printStackTrace();
}
return null;
}
public static void get(){
String sql = " select id,name,brithday from u_stu where id = 2 ";
PreparedStatement ps= null;
Connection conn = getConncetion();
ResultSet rs = null;
try {
ps = conn.prepareStatement(sql);
// ps.setInt(1, 2);
rs = ps.executeQuery();
while (rs.next()){
System.out.println(rs.getInt("id" + "\t"));
System.out.println(rs.getString("name"+ "\t"));
// System.out.println(rs.getDate("birthday"+ "\t"));
}
rs.close();
ps.close();
}catch (SQLException e) {
e.printStackTrace();
}finally{
try {if(conn!=null){conn.close();} }catch (SQLException e) {e.printStackTrace();}
}
}
public static void main(String[] args) {
get();
}
}运行了之后就报 rs = ps.executeQuery();有错。我个人认为是因为是这行的原因:System.out.println(rs.getDate("birthday"+ "\t"));
因为那个getDate()可能不是我想要的getDate()!清师傅们帮忙解决一下,谢谢了!!!求帮助有关jdbc中getDate的问题JDBC
括号错了,变成"id\t"
括号错了,变成"id\t" 写错了,改了后调试成功!
谢谢各位的帮助!!!