jsp连接数据库 各位好,我想用netbeans做一个jsp,服务器是tomcat 6.0,数据库是mysql5.1,请问我生成的.sql文件应该放在哪里?如何才能把数据库和tomcat 6.0关联起来,谢谢各位 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 .sql文件应该是到入数据库的,不是放到哪里mysql < XXX.sql把数据库和tomcat关联,应该是和java程序关联吧,网上google一下。 netbeans做一个jsp,服务器是tomcat 6.0,数据库是mysql5.1,请问我生成的.sql文件应该放在哪里? 如何才能把数据库和tomcat 6.0关联起来首先数据库是如何与你的NETBEANS关联不是和TOMCAT关联。在netbeans里你写个类然后在这个类里写以下代码:public class SqlCon { public static Connection getConnection() throws SQLException , java.lang.ClassNotFoundException{ String url = "jdbc:mysql://localhost:3306/cardrent"; Class.forName("com.mysql.jdbc.Driver"); String userName = "root"; String password = "root"; Connection con = DriverManager.getConnection(url,userName,password); return con; }然后在后面如果用到数据了,就写下面代码Statement st=com.lihan.SqlCon.getConnection().createStatement(); ResultSet rs=st.executeQuery("select * from user "); while(rs.next()) { SelectBean sb = new SelectBean(); sb.setId(rs.getString("id")); sb.setAge(rs.getString("age")); };望成功! 请问各位能帮我解释下面这段代码吗?package cn.edu.uestc.pandawireless;import java.io.IOException;import java.io.InputStream;import java.sql.Connection;import java.sql.DriverManager;import java.sql.PreparedStatement;import java.sql.ResultSet;import java.sql.SQLException;import java.sql.Statement;import java.util.ArrayList;import java.util.Iterator;import java.util.List;import java.util.Properties;public class UserDBBean { private Connection conn; /** * 读取数据库属性文件db.properties中的数据库连接信息 * 并且加载数据库驱动程序 * */ private void init(){ //读取属性文件中的信息// InputStream is = getClass().getResourceAsStream("db.properties");// Properties props = new Properties();// try {// props.load(is);// } catch (IOException e) {// // TODO Auto-generated catch block// e.printStackTrace();// }// //加载驱动程序// String driverclass = props.getProperty("driverclass");// System.out.println(driverclass);// String connecturl = props.getProperty("connecturl"); //System.out.println(connecturl); try { //Class.forName(driverclass).newInstance(); Class.forName("com.mysql.jdbc.Driver").newInstance(); } catch (Exception e) { // TODO Auto-generated catch block e.printStackTrace(); } try { //System.out.println(connecturl); conn = DriverManager.getConnection("jdbc:mysql://192.168.169.20:3306/mlibrary?user=root&password=48805128&useUnicode=true&characterEncoding=UTF-8 //System.out.println(connecturl); } catch (SQLException e) { // TODO Auto-generated catch block //System.out.println(connecturl); e.printStackTrace(); } } /**构造函数 * 初始化数据库连接,加载驱动程序 */ public UserDBBean() { super(); // TODO Auto-generated constructor stub init(); } public boolean hasUser(String uid) { int count = 0; try { Statement stm = conn.createStatement(); ResultSet rs = stm.executeQuery("select count(*) from user where uid = '"+uid+"'"); if(rs.next()){ count = rs.getInt(1); //rs.close(); } stm.close(); rs.close(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } if(count == 0){ return false; }else return true; } public UserBean getUser(String uid) { UserBean user = new UserBean(); user.setUID(uid); try { Statement stm = conn.createStatement(); ResultSet rs = stm.executeQuery("select * from user where uid = '"+uid+"'"); while(rs.next()){ user.setPWD(rs.getString("pwd")); } stm.close(); rs.close(); }catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } return user; } public boolean updateUser(UserBean user){ try { PreparedStatement stmt = conn.prepareStatement("update user set pwd = '"+user.getPWD()+"' where uid = '"+user.getUID()+"'"); stmt.execute(); stmt.close(); return true; } catch (SQLException e) { // TODO Auto-generated catch block return false; } } public void releaseConn(){ try{ if(conn != null) this.conn.close(); }catch(SQLException e ){ } } public static void main(String args[]){ UserBean user = new UserBean(); user.setUID("23456"); user.setPWD("111"); UserDBBean userdb = new UserDBBean(); boolean isSuccess = userdb.updateUser(user); System.out.println(isSuccess); }} 这段代码就是连接数据库,然后建立一个结果集resultsset,从数据库中读出数据,再关闭数据库连接 public static void main(String args[]){ UserBean user = new UserBean(); user.setUID("23456"); user.setPWD("111"); UserDBBean userdb = new UserDBBean(); boolean isSuccess = userdb.updateUser(user); System.out.println(isSuccess); 那么上边这一段呢?用户ID和密码不是记录在数据库里么?这个是什么啊? 如何使用 SQL JSP 标准库http://www.oracle.com/technology/global/cn/sample_code/tech/java/codesnippet/jsps/jstlsql.html 数据库内容是:id|name|birth|sex|addressJSP连接MYSQL,输出代码是:String sql="SELECT * FROM "+tableName;ResultSet rs = statement.executeQuery(sql);//获得数据结果集合ResultSetMetaData rmeta = rs.getMetaData();//确定数据集的列数,亦字段数int numColumns=rmeta.getColumnCount();// 输出每一个数据值out.print("id");out.print("|");out.print("name");out.print("|");out.print("birth");out.print("|");out.print("sex");out.print("|");out.print("address");out.print("<br>");while(rs.next()) {out.print(rs.getString(0)+" ");out.print("|");out.print(rs.getString(2));out.print("|");out.print(rs.getString(3));out.print("|");out.print(rs.getString(4));out.print("|");out.print(rs.getString(5));out.print("<br>");}out.print("<br>");为什么显示的只有:1 |lijing2 |liufei3 |liaoliangping4 |jingyuzhu5 |wanglei后面的3项怎么没出现啊?急求指教。如何能将数据库里的内容都显示出来? 高手说说这两个sql的区别 关于mysql++安装的问题 mysql系统表中查出的TABLE_ROWS不断变化是怎么回事啊 多线程访问这两句代码,是不是要加锁? mysql latin1转gbk的问题 replace语句太可怕了,竟然会这样. 如何在存储过程中判断insert是否成功 如何设置权限 用于mysql的客户端软件是什么?请各位GG给个提示。 谁有有关网站短信的库表设计,能否给我参考参考,感激不尽! mysql存储过程,求救! 一个关于搜索的小题目,帮忙~~
mysql < XXX.sql
把数据库和tomcat关联,应该是和java程序关联吧,网上google一下。
如何才能把数据库和tomcat 6.0关联起来
首先数据库是如何与你的NETBEANS关联不是和TOMCAT关联。在netbeans里你写个类然后在这个类里写以下代码:
public class SqlCon {
public static Connection getConnection() throws SQLException ,
java.lang.ClassNotFoundException{
String url = "jdbc:mysql://localhost:3306/cardrent";
Class.forName("com.mysql.jdbc.Driver");
String userName = "root";
String password = "root";
Connection con = DriverManager.getConnection(url,userName,password);
return con;
}
然后在后面如果用到数据了,就写下面代码Statement st=com.lihan.SqlCon.getConnection().createStatement();
ResultSet rs=st.executeQuery("select * from user ");
while(rs.next())
{
SelectBean sb = new SelectBean();
sb.setId(rs.getString("id"));
sb.setAge(rs.getString("age"));
};
望成功!
package cn.edu.uestc.pandawireless;
import java.io.IOException;
import java.io.InputStream;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.Iterator;
import java.util.List;
import java.util.Properties;
public class UserDBBean {
private Connection conn;
/**
* 读取数据库属性文件db.properties中的数据库连接信息
* 并且加载数据库驱动程序
*
*/
private void init(){
//读取属性文件中的信息
// InputStream is = getClass().getResourceAsStream("db.properties");
// Properties props = new Properties();
// try {
// props.load(is);
// } catch (IOException e) {
// // TODO Auto-generated catch block
// e.printStackTrace();
// }
// //加载驱动程序
// String driverclass = props.getProperty("driverclass");
// System.out.println(driverclass);
// String connecturl = props.getProperty("connecturl");
//System.out.println(connecturl);
try {
//Class.forName(driverclass).newInstance();
Class.forName("com.mysql.jdbc.Driver").newInstance(); } catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
try {
//System.out.println(connecturl);
conn = DriverManager.getConnection("jdbc:mysql://192.168.169.20:3306/mlibrary?user=root&password=48805128&useUnicode=true&characterEncoding=UTF-8
//System.out.println(connecturl);
} catch (SQLException e) {
// TODO Auto-generated catch block
//System.out.println(connecturl);
e.printStackTrace();
}
} /**构造函数
* 初始化数据库连接,加载驱动程序
*/
public UserDBBean() {
super();
// TODO Auto-generated constructor stub
init();
}
public boolean hasUser(String uid)
{
int count = 0;
try {
Statement stm = conn.createStatement();
ResultSet rs = stm.executeQuery("select count(*) from user where uid = '"+uid+"'"); if(rs.next()){
count = rs.getInt(1);
//rs.close();
}
stm.close();
rs.close(); } catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
if(count == 0){
return false;
}else return true;
}
public UserBean getUser(String uid)
{
UserBean user = new UserBean();
user.setUID(uid);
try {
Statement stm = conn.createStatement();
ResultSet rs = stm.executeQuery("select * from user where uid = '"+uid+"'");
while(rs.next()){
user.setPWD(rs.getString("pwd"));
}
stm.close();
rs.close(); }catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return user;
}
public boolean updateUser(UserBean user){
try {
PreparedStatement stmt = conn.prepareStatement("update user set pwd = '"+user.getPWD()+"' where uid = '"+user.getUID()+"'");
stmt.execute();
stmt.close();
return true;
} catch (SQLException e) {
// TODO Auto-generated catch block
return false; }
}
public void releaseConn(){
try{
if(conn != null)
this.conn.close();
}catch(SQLException e ){ } }
public static void main(String args[]){
UserBean user = new UserBean();
user.setUID("23456");
user.setPWD("111");
UserDBBean userdb = new UserDBBean();
boolean isSuccess = userdb.updateUser(user);
System.out.println(isSuccess);
}
}
UserBean user = new UserBean();
user.setUID("23456");
user.setPWD("111");
UserDBBean userdb = new UserDBBean();
boolean isSuccess = userdb.updateUser(user);
System.out.println(isSuccess);
那么上边这一段呢?用户ID和密码不是记录在数据库里么?这个是什么啊?
http://www.oracle.com/technology/global/cn/sample_code/tech/java/codesnippet/jsps/jstlsql.html
JSP连接MYSQL,
输出代码是:
String sql="SELECT * FROM "+tableName;ResultSet rs = statement.executeQuery(sql);//获得数据结果集合ResultSetMetaData rmeta = rs.getMetaData();//确定数据集的列数,亦字段数int numColumns=rmeta.getColumnCount();// 输出每一个数据值out.print("id");out.print("|");out.print("name");
out.print("|");out.print("birth");
out.print("|");out.print("sex");
out.print("|");out.print("address");out.print("<br>");while(rs.next()) {out.print(rs.getString(0)+" ");out.print("|");out.print(rs.getString(2));
out.print("|");out.print(rs.getString(3));
out.print("|");out.print(rs.getString(4));
out.print("|");out.print(rs.getString(5));out.print("<br>");}out.print("<br>");
为什么显示的只有:
1 |lijing
2 |liufei
3 |liaoliangping
4 |jingyuzhu
5 |wanglei
后面的3项怎么没出现啊?
急求指教。如何能将数据库里的内容都显示出来?