正文
j2ee怎么连mysql javaee怎么连接数据库
小程序:扫一扫查出行
【扫一扫了解最新限行尾号】
复制小程序
【扫一扫了解最新限行尾号】
复制小程序
J2EE项目是怎么连接到Mysql数据库的?然后代码是什么呢?
package com.db.connection;
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 javax.sql.DataSource;
import otc.OtcDBcontrol;
public class DBUtil {
public Connection conn;
public ResultSet rs;
public Statement st;
public PreparedStatement ps;
public DataSource ds;
public boolean flag = false;
public DBUtil() throws SQLException {
getConnection();
}
/**
* 打开连接
* @throws SQLException
*/
public void getConnection() throws SQLException {
try {
if (conn == null) {
Class.forName("org.gjt.mm.mysql.Driver");
conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/otc?user=rootpassword=123useUnicode=truecharacterEncoding=UTF-8");
conn.setAutoCommit(false);
}
} catch (Exception e) {
e.printStackTrace();
}
st = conn.createStatement();
}
/**
* 关闭连接
* @throws SQLException
*/
public void close() throws SQLException {
if (st != null) {
st.close();
}
if (conn != null) {
conn.close();
}
}
/**
* 查询
* @param sql
* @return
* @throws SQLException
*/
public ResultSet query(String sql) throws SQLException {
System.out.println(sql);
rs = st.executeQuery(sql);
return rs;
}
/**
* 增删改
* @param sql
* @return
* @throws SQLException
*/
public boolean update(String sql) throws SQLException {
System.out.println(sql);
int s = 1;
s = st.executeUpdate(sql);
if (s != 0) {
conn.setAutoCommit(false);
conn.commit();
flag = true;
} else {
conn.rollback();
flag = false;
}
return flag;
}
}
这个是代码j2ee怎么连mysql,只需要改你自己j2ee怎么连mysql的数据库用户名密码就可以j2ee怎么连mysql了~
J2EE:请问,新建项目中如何使用Tomcat连接Mysql时server.xml里的
使用JNDI数据源啊。
大约是 java/jsp/servlet/ ---- JNDI ---JDBC -- Datbase.
我的eclipse是j2ee版本的,安装了flex插件,想要连接mysql,请问步骤是怎么样的?学习flex的新手
private static final String Driver="com.microsoft.sqlserver.jdbc.SQLServerDriver";
private static final String URL="jdbc:sqlserver://localhost:1433;databaseName=company";
private static final String UserName="sa";
private static final String UserPass="sqlpass";
public static Connection getCon(){
Connection con = null;
try {
Class.forName(Driver);
con=DriverManager.getConnection(URL,UserName,UserPass); //连接数据库
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return con;
}
你把url改成mysql的就行了
还有把mysql的jar复制到lib文件下。
如何用JSP servlet完成一个简单的登录页面连接mysql数
第一步j2ee怎么连mysql:web.xml
Java code?
?xml version="1.0" encoding="UTF-8"?
web-app version="2.5" xmlns=""
xmlns:xsi=""
xsi:schemaLocation="
"
welcome-file-list
welcome-filelogin.jsp/welcome-file
/welcome-file-list
servlet
descriptionThis is the description of my J2EE component/description
display-nameThis is the display name of my J2EE component/display-name
servlet-nameloginServlet/servlet-name
servlet-classcom.servlet.loginServlet/servlet-class
/servlet
servlet-mapping
servlet-nameloginServlet/servlet-name
url-pattern/loginServlet/url-pattern
/servlet-mapping
/web-app
第二步j2ee怎么连mysql:数据库
Java code?
/*
SQLyog Ultimate v8.32
MySQL - 5.5.23 : Database - student
*********************************************************************
*/
/*!40101 SET NAMES utf8 */;
/*!40101 SET SQL_MODE=''*/;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
CREATE DATABASE /*!32312 IF NOT EXISTS*/`student` /*!40100 DEFAULT CHARACTER SET utf8 */;
USE `student`;
/*Table structure for table `user` */
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user` varchar(50) NOT NULL,
`pwd` varchar(50) NOT NULL,
`name` varchar(50) NOT NULL,
`age` int(50) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
/*Data for the table `user` */
insert into `user`(`id`,`user`,`pwd`,`name`,`age`) values (1,'zhangsan','123','张三',21);
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
第三步:登录login.jsp
Java code?
%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%
!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
html
head
titlexx系统/title
meta http-equiv="pragma" content="no-cache"
meta http-equiv="cache-control" content="no-cache"
meta http-equiv="expires" content="0"
meta http-equiv="keywords" content="keyword1,keyword2,keyword3"
meta http-equiv="description" content="This is my page"
!--
link rel="stylesheet" type="text/css" href="styles.css"
--
/head
body
div align="center" font size=" 2" color="#FF6633"用户登录/font
/div
form id="form1" name="form1" method="post" action="loginServlet"
table width="357" border="0" align="center"
tr
td width="128"用户名:/td
td width="219"label
input name="user" type="text" id="user" /
/label/td
/tr
tr
td密 码:/td
tdlabel
input name="pwd" type="password" id="pwd" /
/label/td
/tr
tr
tdlabel
input type="submit" name="Submit" value="登录" /
/label/td
/tr
/table
pnbsp;/p
/form
/body
/html
第四步:success.jsp
Java code
%@ page language="java" contentType="text/html; charset=ISO-8859-1"
pageEncoding="ISO-8859-1"%
!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" ""
html
head
meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1"
titleInsert title here/title
/head
body
${address }/br
${port }/br
/body
/html
第五步:loginServlet.java
Java code
package com.servlet;
import java.io.IOException;
import java.io.PrintWriter;
import java.net.InetAddress;
import java.sql.SQLException;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;
import com.dao.Dao;
public class loginServlet extends HttpServlet {
public void destroy() {
super.destroy(); // Just puts "destroy" string in log
// Put your code here
}
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
request.setCharacterEncoding("utf-8");
response.setContentType("text/html");
PrintWriter out = response.getWriter();
String name = new String(request.getParameter("user").getBytes(
"ISO8859_1"), "GBK");
String pwd = new String(request.getParameter("pwd").getBytes(
"ISO8859_1"), "UTF-8");
User user = new User();
user.setUser(name);
user.setPwd(pwd);
Dao dao = new Dao();
boolean isLogin;
try {
isLogin = dao.logoin(user);
if (isLogin) {
InetAddress inetAddress = InetAddress.getLocalHost();
String m = inetAddress.getHostAddress();
int n = request.getRemotePort();
System.out.println(m+"*********"+ n);
HttpSession session = request.getSession();
session.setAttribute("address", m);
session.setAttribute("port", n);
response.sendRedirect("success.jsp");
} else {
response.sendRedirect("index.jsp");
}
} catch (SQLException e) {
e.printStackTrace();
}
}
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
doPost(request, response);
}
public void init() throws ServletException {
}
}
Java code
package com.servlet;
public class User {
private String user;
private String pwd;
private String name;
private int age;
public String getUser() {
return user;
}
public void setUser(String user) {
this.user = user;
}
public String getPwd() {
return pwd;
}
public void setPwd(String pwd) {
this.pwd = pwd;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public int getAge() {
return age;
}
public void setAge(int age) {
this.age = age;
}
}
Java code?
package com.util;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
public class GetConnection {
//通过静态方法注册驱动j2ee怎么连mysql,获得连接
public static Connection getConnection(){
String driver = "com.mysql.jdbc.Driver";
String url = "jdbc:mysql://localhost/student";
Connection con = null;
try {
Class.forName(driver);
try {
con = DriverManager.getConnection(url,"root","123456");
} catch (SQLException e) {
e.printStackTrace();
}
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
System.out.println("已获得数据库j2ee怎么连mysql的连接");
return con;
}
/*public static void main(String args[]){
getConnection();
}*/
}
Java code?
package com.dao;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import com.servlet.User;
import com.util.GetConnection;
public class Dao {
private Connection conn;
private PreparedStatement pstat;
String sql = "";
/**
*
* 用户登录
*/
public boolean logoin(User user) throws SQLException {
conn = GetConnection.getConnection();
boolean i = false;
sql = "select * from user where user=? and pwd=?";
pstat = conn.prepareStatement(sql);
pstat.setString(1, user.getUser());
pstat.setString(2, user.getPwd());
ResultSet rs1 = (ResultSet) pstat.executeQuery();
if (rs1.next()) {
i = true;
rs1.close();
pstat.close();
} else {
i = false;
rs1.close();
pstat.close();
}
conn.close();
return i;
}
/**
* 用户注册
*/
public void addUser(User user) {
conn = GetConnection.getConnection();
sql = "insert into user values(?,?,?,?)";
try {
pstat = conn.prepareStatement(sql);
pstat.setString(1, user.getUser());
pstat.setString(2, user.getPwd());
pstat.setString(3, user.getName());
pstat.setInt(5, user.getAge());
pstat.executeUpdate();
pstat.close();
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
注意事项:1.数据库用户密码j2ee怎么连mysql;2.访问地址。
j2ee怎么连mysql的介绍就聊到这里吧,感谢你花时间阅读本站内容,更多关于javaee怎么连接数据库、j2ee怎么连mysql的信息别忘了在本站进行查找喔。