怎样往mysql里面写东西_【求助】纯java如何往数据库里写东西？大神救我！QAQ

该楼层疑似违规已被系统折叠 隐藏此楼查看此楼

先构造添加数据的SQL语句，用insert。

下面是我写过的一个函数，希望对你有用

public int conAddProblem()

{

String url = "jdbc:mysql://127.0.0.1:3306/test";

String user = "root";

String password = "";

int result=0;

try

{

Class.forName("com.mysql.jdbc.Driver");

Connection conn = DriverManager.getConnection(url, user, password);

if(!conn.isClosed())

System.out.println("Succeeded connecting to the Database!");

Statement sm = conn.createStatement();

String temp="\'"+JTFkemu.getText()+"\',\'"+answer.getText()+"\',\'"+JTFfenshu.getText()+"\',\'"+

answers4.getText()+"\',\'"+answers3.getText()+"\',\'"+answers2.getText()+"\',\'"+

answers1.getText()+"\',\'"+problem.getText()+"\',\'"+1+"\'";

String sql ="insert into questionlist(subject,rightanswer,score,answerD,answerC,answerB,answerA,question,level) values("+temp+")";

System.out.println(sql);

result=sm.executeUpdate(sql);

System.out.println(result);

sm.close();

conn.close();

}

catch(SQLException e){}

catch(ClassNotFoundException e){}

return result;

}

各别函数有不明白的就百度吧