jsp
String sql =("insert into admin_user(admin_user,admin_pssd,admin_name1,admin_name2,admin_bumen,admin_email,admin_dianhua) values('"+username+"','"+pass1+"','"+username1+"','"+username2+"','"+bumen+"','"+email+"','"+dianhua+"')");
yctgmysql.executeUpdate(sql);
bean
package bean;
import java.net.*;
import java.sql.*;
import java.lang.*;
import java.io.*;
import java.util.*;public class yctgmysql
{
private Connection conn = null;
private ResultSet RS_result = null;
private String server = "localhost:3306"; // Can't use localhost , you must use IP or CNAME .:3306
private String db = "net_must"; //change to your db name
private String user = "root"; //change to your username
private String pass = "founder"; //change to your password
private String drivername="com.mysql.jdbc.Driver"; //mysql driver
private String URL="jdbc:mysql://"+server+"/"+db+"?useUnicode=true&characterEncoding=GBK&user="+user+"&password="+pass;
public Connection getConn()
{ //get database connection
try
{
Class.forName(drivername).newInstance(); //载入驱动器
conn = DriverManager.getConnection(URL); //连接到数据库
}
catch(Exception e)
{
e.printStackTrace();
}
return conn ;
}
public ResultSet executeSQL(String str)
{
try{
Statement stmt = conn.createStatement(); //语句接口
RS_result = stmt.executeQuery(str); //获得结果集
}
catch(Exception e)
{
e.printStackTrace();
}
return RS_result;
}
public boolean executeUpdate(String str)
{
boolean RS_res=false;
try{
Statement stmt = conn.createStatement(); //语句接口
int RS_res = stmt.executeUpdate(str); //获得结果集
}
catch(Exception e)
{
e.printStackTrace();
}
return RS_res;
}
public void executeUpdate(String sql) {
try {
Statement stmt = conn.createStatement();
stmt.executeUpdate(sql);
stmt.close();
} catch (SQLException ex) {
System.err.println("sss:" + ex.getMessage());
}
}
}
String sql =("insert into admin_user(admin_user,admin_pssd,admin_name1,admin_name2,admin_bumen,admin_email,admin_dianhua) values('"+username+"','"+pass1+"','"+username1+"','"+username2+"','"+bumen+"','"+email+"','"+dianhua+"')");
yctgmysql.executeUpdate(sql);
bean
package bean;
import java.net.*;
import java.sql.*;
import java.lang.*;
import java.io.*;
import java.util.*;public class yctgmysql
{
private Connection conn = null;
private ResultSet RS_result = null;
private String server = "localhost:3306"; // Can't use localhost , you must use IP or CNAME .:3306
private String db = "net_must"; //change to your db name
private String user = "root"; //change to your username
private String pass = "founder"; //change to your password
private String drivername="com.mysql.jdbc.Driver"; //mysql driver
private String URL="jdbc:mysql://"+server+"/"+db+"?useUnicode=true&characterEncoding=GBK&user="+user+"&password="+pass;
public Connection getConn()
{ //get database connection
try
{
Class.forName(drivername).newInstance(); //载入驱动器
conn = DriverManager.getConnection(URL); //连接到数据库
}
catch(Exception e)
{
e.printStackTrace();
}
return conn ;
}
public ResultSet executeSQL(String str)
{
try{
Statement stmt = conn.createStatement(); //语句接口
RS_result = stmt.executeQuery(str); //获得结果集
}
catch(Exception e)
{
e.printStackTrace();
}
return RS_result;
}
public boolean executeUpdate(String str)
{
boolean RS_res=false;
try{
Statement stmt = conn.createStatement(); //语句接口
int RS_res = stmt.executeUpdate(str); //获得结果集
}
catch(Exception e)
{
e.printStackTrace();
}
return RS_res;
}
public void executeUpdate(String sql) {
try {
Statement stmt = conn.createStatement();
stmt.executeUpdate(sql);
stmt.close();
} catch (SQLException ex) {
System.err.println("sss:" + ex.getMessage());
}
}
}
解决方案 »
- 这段滚动Js代码,哪里是控制图片数量的设置
- apache负载均衡时如何根据IP段分配指定Tomcat处理?
- filter控制用户访问权限?
- 在JSP程序中两个 float型的数:0.88 , 16.5 相乘 等于 14.5199995 ,为什么不是14.52
- 下载了jbuilder2005,共900多mb,但是不会安装,请教
- 求助发送到远程机器xml:Premature end of file错误
- smartupload 下载文件
- 输入框中要求输入0-100的整数,怎样避免输入字符,标点,小数...?
- 救命啊!!!!
- 如何判断tomcat4。1。18安装正常
- 上传JSP程序实现服务器重启
- 十万火急的jsp标准动作问题 动态设定jsp include page的值,简单思路就是不知道怎么实现 实现了就加最高的分
import java.net.*;
import java.sql.*;
import java.lang.*;
import java.io.*;
import java.util.*;public class yctgmysql
{
private Connection conn = null;
private ResultSet RS_result = null;
private boolean RS_res;
private String server = "localhost:3306"; // Can't use localhost , you must use IP or CNAME .:3306
private String db = "net_must"; //change to your db name
private String user = "root"; //change to your username
private String pass = "founder"; //change to your password
private String drivername="com.mysql.jdbc.Driver"; //mysql driver
private String URL="jdbc:mysql://"+server+"/"+db+"?useUnicode=true&characterEncoding=GBK&user="+user+"&password="+pass;
public Connection getConn()
{ //get database connection
try
{
Class.forName(drivername).newInstance(); //载入驱动器
conn = DriverManager.getConnection(URL); //连接到数据库
}
catch(Exception e)
{
e.printStackTrace();
}
return conn ;
}
public ResultSet executeSQL(String str)
{
try{
Statement stmt = conn.createStatement(); //语句接口
RS_result = stmt.executeQuery(str); //获得结果集
}
catch(Exception e)
{
e.printStackTrace();
}
return RS_result;
}
public boolean executeUpdate(String str)
{
try{
Statement stmt = conn.createStatement(); //语句接口
int RS_res = stmt.executeUpdate(str); //获得结果集
}
catch(Exception e)
{
e.printStackTrace();
}
return RS_res;
}
}
{ try{
Statement stmt = conn.createStatement(); //语句接口
int RS_res = stmt.executeUpdate(str); //获得结果集
}
catch(Exception e)
{
e.printStackTrace();
}
return RS_res;
}
}
[/code]
conn貌似空的,你先调用getConn()方法获得conn实例
添加一句
conn=getConn();
这个不报错????