java 数据库 求java连接数据库的 插入操作的语句最好详细点谢谢 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 Connection con ; Statement stmt; ResultSet rs; DriverManager.registerDriver(new sun.jdbc.odbc.JdbcOdbcDriver()); con =DriverManager.getConnection("jdbc:odbc:Persons"); stmt =con.createStatement(); rs =stmt.executeQuery("select * from person order by ID"); 最好使用数据池 楼上写的不太好 因为Connection不是线程安全的的 Class.forName("com.mysql.jdbc.Driver"); String url = "jdbc:mysql://localhost/bbs?user=root&password=123456"; Connection conn = DriverManager.getConnection(url); conn.setAutoCommit(false); String sql = "insert into MessageBoard values (null, ?, ?, now())"; PreparedStatement pstmt = conn.prepareStatement(sql); Statement stmt = conn.createStatement(); pstmt.setString(1,title); pstmt.setString(2,cont); pstmt.executeUpdate();这个 Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); String url="jdbc:odbc:Driver={Microsoft Excel Driver (*.xls)};DBQ=test.xls"; Connection con=DriverManager.getConnection(url); con.setAutoCommit(false); String sql="insert into [Sheet1$] values(?,?,?,?,?,?)"; PreparedStatement stm2=con.prepareStatement(sql); stm2.setString(1,"sdf"); stm2.setString(2,"sdf"); stm2.setString(3,"sdf"); stm2.setString(4,"sdf"); stm2.setString(5,"sdf"); stm2.setString(6,"sdf"); stm2.executeUpdate(); con.close();这是我的代码,但运行起来异常是驱动可选功能未能实现,这是为啥,请教大家,本人太菜鸟.... public static void main(String[] args){ try{ Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver"); Connection con =DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=pubs","sa","coolcool"); System.out.println("连接成功"); Statement s = con.createStatement(); ResultSet rs = s.executeQuery("select * from jobs");(换成insert) while(rs.next()){ System.out.println("--------"+rs.getString(1)); } }catch(Exception e){ System.out.println("连接失败!"+e.getMessage()); } } 代码如下,测试通过,数据的查询和插入:假如SQL SERVER 服务器的IP为,192.168.1.110,用户名: sa , 密码sa ,数据库名: DB01, 该库中有表 BookName(字段:ID,CategoryCode,BookCode,BookName),工程名称:J2SE004--------------------------------------------------------------------------------------------package sour001;import java.sql.*; import java.net.URL;import javax.sql.*;import java.net.*;import com.microsoft.*;public class J2SE004 { public static void main(String[] args) { try{ Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance(); System.out.println("数据库驱动程序注册成功!"); System.out.print("DriverClass: com.microsoft.jdbc.sqlserver.SQLServerDriver"); String JDBC_url ="jdbc:microsoft:sqlserver://192.168.1.110:1433;DatabaseName=DB01"; String DBuser="sa"; String DBpsw="sa"; Statement stmt=null; ResultSet rs=null; ResultSet rs2=null; Connection conn=null; String xsql="select * from BookName"; conn = DriverManager.getConnection(JDBC_url, DBuser, DBpsw); System.out.println("\n\n数据库连接成功"); System.out.print(JDBC_url); //-------------------------------------------- //数据查询 stmt=conn.createStatement(java.sql.ResultSet.TYPE_SCROLL_INSENSITIVE,java.sql.ResultSet.CONCUR_UPDATABLE); rs=stmt.executeQuery(xsql); System.out.println("\n\n读取数据......\n"); System.out.println("ID\tCategoryCode\tBookCode\tBookName"); for(int i=0;i<70;i++) System.out.print("-"); System.out.println(""); while(rs.next()) { System.out.print(rs.getInt(1)+"\t"); System.out.print(rs.getString(2)+"\t\t"); System.out.print(rs.getString(3)+"\t\t"); System.out.print(rs.getString(4)+"\t\t\n"); } for(int i=0;i<70;i++) System.out.print("-"); System.out.println(""); System.out.println("\n读取数据完毕."); //-------------------------------------------------------- //向表中插入一条数据 xsql="insert into BookName(CategoryCode,BookCode,BookName) values ('004','0040005','十万个为什么')"; stmt.execute(xsql); //也可以stmt.executeUpdate(xsql); //-------------------------------------------------------- rs.close(); rs2.close(); stmt.close(); conn.close(); }catch(Exception e01){ e01.printStackTrace(); System.out.println("数据库连接失败"); System.out.println(e01.toString());} }} 大家帮忙看看这段代码为什么错误呢? 请教时间的转化问题:Calendar 到 Date. 小程序求助 URL 和 Socket 有什么不同? 急求一个随机算法的小程序!!! 关于TOMCAT的配置. 如何在java程序中设置断点进行调试,我用的是VisualAge for Java. 只好重新问一次:java如何作report? java swing程序导出带第三方jar包的项目时报错 新手小问题求解答 请教一下,如何在SQL 2000中创建一个名为“学生”的数据库? main方法中的main方法
Statement stmt;
ResultSet rs; DriverManager.registerDriver(new sun.jdbc.odbc.JdbcOdbcDriver());
con =DriverManager.getConnection("jdbc:odbc:Persons");
stmt =con.createStatement();
rs =stmt.executeQuery("select * from person order by ID");
楼上写的不太好 因为Connection不是线程安全的的
String url = "jdbc:mysql://localhost/bbs?user=root&password=123456";
Connection conn = DriverManager.getConnection(url); conn.setAutoCommit(false); String sql = "insert into MessageBoard values (null, ?, ?, now())";
PreparedStatement pstmt = conn.prepareStatement(sql);
Statement stmt = conn.createStatement(); pstmt.setString(1,title);
pstmt.setString(2,cont);
pstmt.executeUpdate();这个
String url="jdbc:odbc:Driver={Microsoft Excel Driver (*.xls)};DBQ=test.xls";
Connection con=DriverManager.getConnection(url);
con.setAutoCommit(false);
String sql="insert into [Sheet1$] values(?,?,?,?,?,?)";
PreparedStatement stm2=con.prepareStatement(sql);
stm2.setString(1,"sdf");
stm2.setString(2,"sdf");
stm2.setString(3,"sdf");
stm2.setString(4,"sdf");
stm2.setString(5,"sdf");
stm2.setString(6,"sdf");
stm2.executeUpdate();
con.close();这是我的代码,但运行起来异常是驱动可选功能未能实现,这是为啥,请教大家,本人太菜鸟....
try{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
Connection con =DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=pubs","sa","coolcool");
System.out.println("连接成功");
Statement s = con.createStatement();
ResultSet rs = s.executeQuery("select * from jobs");(换成insert)
while(rs.next()){
System.out.println("--------"+rs.getString(1));
}
}catch(Exception e){
System.out.println("连接失败!"+e.getMessage());
}
}
--------------------------------------------------------------------------------------------package sour001;
import java.sql.*;
import java.net.URL;
import javax.sql.*;
import java.net.*;
import com.microsoft.*;public class J2SE004 {
public static void main(String[] args) {
try{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
System.out.println("数据库驱动程序注册成功!");
System.out.print("DriverClass: com.microsoft.jdbc.sqlserver.SQLServerDriver"); String JDBC_url ="jdbc:microsoft:sqlserver://192.168.1.110:1433;DatabaseName=DB01";
String DBuser="sa";
String DBpsw="sa";
Statement stmt=null;
ResultSet rs=null;
ResultSet rs2=null;
Connection conn=null; String xsql="select * from BookName";
conn = DriverManager.getConnection(JDBC_url, DBuser, DBpsw);
System.out.println("\n\n数据库连接成功");
System.out.print(JDBC_url);
//--------------------------------------------
//数据查询
stmt=conn.createStatement(java.sql.ResultSet.TYPE_SCROLL_INSENSITIVE,java.sql.ResultSet.CONCUR_UPDATABLE);
rs=stmt.executeQuery(xsql);
System.out.println("\n\n读取数据......\n");
System.out.println("ID\tCategoryCode\tBookCode\tBookName");
for(int i=0;i<70;i++)
System.out.print("-");
System.out.println("");
while(rs.next())
{
System.out.print(rs.getInt(1)+"\t");
System.out.print(rs.getString(2)+"\t\t");
System.out.print(rs.getString(3)+"\t\t");
System.out.print(rs.getString(4)+"\t\t\n");
}
for(int i=0;i<70;i++)
System.out.print("-");
System.out.println("");
System.out.println("\n读取数据完毕.");
//--------------------------------------------------------
//向表中插入一条数据
xsql="insert into BookName(CategoryCode,BookCode,BookName) values ('004','0040005','十万个为什么')";
stmt.execute(xsql); //也可以stmt.executeUpdate(xsql);
//--------------------------------------------------------
rs.close();
rs2.close();
stmt.close();
conn.close();
}catch(Exception e01){
e01.printStackTrace();
System.out.println("数据库连接失败");
System.out.println(e01.toString());}
}
}