Question

用JAVA往数据库写入数据,既没有抛出异常,也没有写入成功,求高手指教？？？急啊！

import java.sql.*;
import java.io.*;
import java.util.*;

public class text{
public static void writers(String a,String b,String c) throws Exception{
String sql="insert into Table3 values('"+a+"','"+b+"','"+c+"')";
try{
Connection conn;
conn=DriverManager.getConnection("jdbc:odbc:zhouyun");
conn.prepareStatement(sql);
}catch(SQLException e){
e.printStackTrace();
}
}

public static void main(String args[]) throws Exception{
text.writers("yunchen",null,null);
System.out.println("shuruok");
}
}

Answer 1

你要多去看看API了
prepareStatement(sql)只是预编译sql了，还需要执行SQL
PreparedStatement sta = conn.prepareStatement(sql);
sta.set....(); //设置SQL中参数
sta.execute();//执行预编译后的SQL
具体的可以查看API

Answer 2

Statement haha = conn.prepareStatement(sql);
haha.updatee....();//忘记了

Answer 3

import java.sql.*;
import java.io.*;
import java.util.*;

public class text{
public static void writers(String a,String b,String c) throws Exception{
PreparedStatement pstmt = null;
String sql="insert into Table3 values('"+a+"','"+b+"','"+c+"')";
try{
Connection conn;
conn=DriverManager.getConnection("jdbc:odbc:zhouyun");
pstmt= conn.prepareStatement(sql);
pstmt.executeUpdate();
}catch(SQLException e){
e.printStackTrace();
}
}

public static void main(String args[]) throws Exception{
text.writers("yunchen",null,null);
System.out.println("shuruok");
}
}

Answer 4

try{
Connection conn;
conn=DriverManager.getConnection("jdbc:odbc:zhouyun");
Statement st=con.createStatement();
int a=st.executeUpdate(sql);
if(a>0){
System.out.println("执行成功");}
}catch(SQLException e){
e.printStackTrace();
}