Question

在jsp页面中往mysql插入一条数据库 求助

String uname = request.getParameter("uname"); String password = request.getParameter("pwd");Class.forName("com.mysql.jdbc.Driver"); String url = "jdbc:mysql://localhost/bbs?user=root&password=root"; Connection conn = DriverManager.getConnection(url); String sql = "insert into user values(null,uname,password)"; Statement stmt = conn.createStatement();接下来要怎么写？

Answer 1

sql语句不对：sql="insert into user values(' "+""+" ',' "+unname+" ',' "+password+" ' )";下面:
stmt.excuteUpdate(sql);

Answer 2

何必这么麻烦