javaservelt连接mysql_servlet中Java连接数据库后的基本操作

import     java.io.IOException;

import     java.io.PrintWriter;

import java.sql.Connection;

import     java.sql.DriverManager;

import     java.sql.PreparedStatement;

import     java.sql.ResultSet;

import     java.sql.SQLException;

import     java.util.ArrayList;

import     java.util.List;

import     javax.servlet.ServletException;

import     javax.servlet.http.HttpServlet;

import     javax.servlet.http.HttpServletRequest;

import     javax.servlet.http.HttpServletResponse;

public class     LoginServlet extends HttpServlet{

@Override

protected void     doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException,     IOException {

// TODO     Auto-generated method stub

//处理中文的乱码

resp.setContentType("text/html;charset=utf-8");//响应

req.setCharacterEncoding("utf-8");     //请求

String name =     req.getParameter("username"); //username是输入框对应的name                          String pwd =     req.getParameter("pwd");                          try {

try {

//表单填写的都是字符串

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

Connection     connection =     DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/login",     "root", "yufei");

//                                             System.out.println(connection);

String     sql = "select * from conn where name=? and pwd=? ;";

PreparedStatement     preparedStatement = connection.prepareStatement(sql);

System.out.println("name:"+name+"============"     +"pwd" + pwd);

preparedStatement.setString(1,     name);

preparedStatement.setString(2,     pwd);

ResultSet     re = preparedStatement.executeQuery();

PrintWriter     out = resp.getWriter();

out.print("

==========

");

String     sql1 = "select * from student";

PreparedStatement     sprint = connection.prepareStatement(sql1);

ResultSet     studinf = sprint.executeQuery();

while(re.next()){

out.print("

登录成功

");

out.print("

学生的信息是:

");

while(studinf.next()){

out.print("

学生的姓名是:"+     studinf.getString("name")+"===id号:"+studinf.getString("id")+"===性别是:"+studinf.getString("gender")+"===年龄是:"+studinf.getString("age")+"

");

}

return;//终止程序

}

out.print("

登录失败

");

} catch     (SQLException e) {

//     TODO Auto-generated catch block

e.printStackTrace();

}

} catch     (ClassNotFoundException e) {

// TODO     Auto-generated catch block

e.printStackTrace();

}

}

//form默认的提交方式是get

@Override

protected void doGet(HttpServletRequest     req, HttpServletResponse resp) throws ServletException, IOException {

// TODO     Auto-generated method stub

doPost(req,resp);

}

}