UC知道JAVA高手帮一下，数据库问题
来源：百度知道 编辑：UC知道 时间：2024/05/24 12:22:36
帮忙看一下SQL语句哪里有问题，谢谢
public void test(){
try{
String strurl="jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=D:/Java/workplace/my1/my1.mdb";
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection conn=DriverManager.getConnection(strurl) ;
Statement statement = conn.createStatement();
String s1="'"+t1.getText()+"'",s2="'"+t2.getText()+"'",
s3="'"+t4.getText()+"'",ss="'"+t3.getText()+"'";
//ResultSet s4 = statement.executeQuery("select kh_id from KH;");
//ResultSet s5 = statement.executeQuery("select qc_id form QC;");
String sql="insert into KH(kh_id,kh_name) values("+s1+","+s2+")";
//String sql2="insert into SY(sy_id,kh_id,qc_id,sy_time,sy_yj) values("+s
public void test(){
try{
String strurl="jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=D:/Java/workplace/my1/my1.mdb";
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection conn=DriverManager.getConnection(strurl) ;
Statement statement = conn.createStatement();
String s1="'"+t1.getText()+"'",s2="'"+t2.getText()+"'",
s3="'"+t4.getText()+"'",ss="'"+t3.getText()+"'";
//ResultSet s4 = statement.executeQuery("select kh_id from KH;");
//ResultSet s5 = statement.executeQuery("select qc_id form QC;");
String sql="insert into KH(kh_id,kh_name) values("+s1+","+s2+")";
//String sql2="insert into SY(sy_id,kh_id,qc_id,sy_time,sy_yj) values("+s
String sql3="select kh_name,qc_name,qc_price,sy_time,sy_yj from KH where KH.kh_id=SY.kh_id and QC.qc_id=SY.qc_id";
修改为
String sql3="select KH.kh_name,QC.qc_name,QC.qc_price,SY.sy_time,SY.sy_yj from KH，SY，QC where KH.kh_id=SY.kh_id and QC.qc_id=SY.qc_id";
你把你的sql语句打印出来
然后粘贴到数据库上试试
还有 下回发问题的时候麻烦你把你的错误一起发出来行不行....
自己不会 System.out.println(sql)吗？
而且你的代码不完整。
String sql="insert into KH(kh_id,kh_name) values("+s1+","+s2+")"; 中
s2是从哪来的。
还有好多问题。