Page Menu
Home
c4science
Search
Configure Global Search
Log In
Files
F99153865
DBconnector_mu.html
No One
Temporary
Actions
Download File
Edit File
Delete File
View Transforms
Subscribe
Mute Notifications
Award Token
Subscribers
None
File Metadata
Details
File Info
Storage
Attached
Created
Tue, Jan 21, 19:08
Size
16 KB
Mime Type
text/html
Expires
Thu, Jan 23, 19:08 (2 d)
Engine
blob
Format
Raw Data
Handle
23721121
Attached To
R3229 Genome Privacy - SHCS App
DBconnector_mu.html
View Options
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<!-- NewPage -->
<html
lang=
"en"
>
<head>
<!-- Generated by javadoc (version 1.7.0_17) on Fri Jan 10 14:26:10 CET 2014 -->
<title>
DBconnector_mu
</title>
<meta
name=
"date"
content=
"2014-01-10"
>
<link
rel=
"stylesheet"
type=
"text/css"
href=
"../stylesheet.css"
title=
"Style"
>
</head>
<body>
<script
type=
"text/javascript"
>
<!--
if
(
location
.
href
.
indexOf
(
'is-external=true'
)
==
-
1
)
{
parent
.
document
.
title
=
"DBconnector_mu"
;
}
//-->
</script>
<noscript>
<div>
JavaScript is disabled on your browser.
</div>
</noscript>
<!-- ========= START OF TOP NAVBAR ======= -->
<div
class=
"topNav"
><a
name=
"navbar_top"
>
<!-- -->
</a><a
href=
"#skip-navbar_top"
title=
"Skip navigation links"
></a><a
name=
"navbar_top_firstrow"
>
<!-- -->
</a>
<ul
class=
"navList"
title=
"Navigation"
>
<li><a
href=
"../overview-summary.html"
>
Overview
</a></li>
<li><a
href=
"package-summary.html"
>
Package
</a></li>
<li
class=
"navBarCell1Rev"
>
Class
</li>
<li><a
href=
"class-use/DBconnector_mu.html"
>
Use
</a></li>
<li><a
href=
"package-tree.html"
>
Tree
</a></li>
<li><a
href=
"../deprecated-list.html"
>
Deprecated
</a></li>
<li><a
href=
"../index-files/index-1.html"
>
Index
</a></li>
<li><a
href=
"../help-doc.html"
>
Help
</a></li>
</ul>
</div>
<div
class=
"subNav"
>
<ul
class=
"navList"
>
<li>
Prev Class
</li>
<li><a
href=
"../medical_unit/GUI.html"
title=
"class in medical_unit"
><span
class=
"strong"
>
Next Class
</span></a></li>
</ul>
<ul
class=
"navList"
>
<li><a
href=
"../index.html?medical_unit/DBconnector_mu.html"
target=
"_top"
>
Frames
</a></li>
<li><a
href=
"DBconnector_mu.html"
target=
"_top"
>
No Frames
</a></li>
</ul>
<ul
class=
"navList"
id=
"allclasses_navbar_top"
>
<li><a
href=
"../allclasses-noframe.html"
>
All Classes
</a></li>
</ul>
<div>
<script
type=
"text/javascript"
>
<!--
allClassesLink
=
document
.
getElementById
(
"allclasses_navbar_top"
);
if
(
window
==
top
)
{
allClassesLink
.
style
.
display
=
"block"
;
}
else
{
allClassesLink
.
style
.
display
=
"none"
;
}
//-->
</script>
</div>
<div>
<ul
class=
"subNavList"
>
<li>
Summary:
</li>
<li>
Nested
|
</li>
<li><a
href=
"#field_summary"
>
Field
</a>
|
</li>
<li><a
href=
"#constructor_summary"
>
Constr
</a>
|
</li>
<li><a
href=
"#method_summary"
>
Method
</a></li>
</ul>
<ul
class=
"subNavList"
>
<li>
Detail:
</li>
<li><a
href=
"#field_detail"
>
Field
</a>
|
</li>
<li><a
href=
"#constructor_detail"
>
Constr
</a>
|
</li>
<li><a
href=
"#method_detail"
>
Method
</a></li>
</ul>
</div>
<a
name=
"skip-navbar_top"
>
<!-- -->
</a></div>
<!-- ========= END OF TOP NAVBAR ========= -->
<!-- ======== START OF CLASS DATA ======== -->
<div
class=
"header"
>
<div
class=
"subTitle"
>
medical_unit
</div>
<h2
title=
"Class DBconnector_mu"
class=
"title"
>
Class DBconnector_mu
</h2>
</div>
<div
class=
"contentContainer"
>
<ul
class=
"inheritance"
>
<li>
java.lang.Object
</li>
<li>
<ul
class=
"inheritance"
>
<li>
medical_unit.DBconnector_mu
</li>
</ul>
</li>
</ul>
<div
class=
"description"
>
<ul
class=
"blockList"
>
<li
class=
"blockList"
>
<hr>
<br>
<pre>
public class
<span
class=
"strong"
>
DBconnector_mu
</span>
extends java.lang.Object
</pre>
<dl><dt><span
class=
"strong"
>
Author:
</span></dt>
<dd>
raisaro
</dd></dl>
</li>
</ul>
</div>
<div
class=
"summary"
>
<ul
class=
"blockList"
>
<li
class=
"blockList"
>
<!-- =========== FIELD SUMMARY =========== -->
<ul
class=
"blockList"
>
<li
class=
"blockList"
><a
name=
"field_summary"
>
<!-- -->
</a>
<h3>
Field Summary
</h3>
<table
class=
"overviewSummary"
border=
"0"
cellpadding=
"3"
cellspacing=
"0"
summary=
"Field Summary table, listing fields, and an explanation"
>
<caption><span>
Fields
</span><span
class=
"tabEnd"
>
</span></caption>
<tr>
<th
class=
"colFirst"
scope=
"col"
>
Modifier and Type
</th>
<th
class=
"colLast"
scope=
"col"
>
Field and Description
</th>
</tr>
<tr
class=
"altColor"
>
<td
class=
"colFirst"
><code>
private java.sql.Connection
</code></td>
<td
class=
"colLast"
><code><strong><a
href=
"../medical_unit/DBconnector_mu.html#connect"
>
connect
</a></strong></code>
</td>
</tr>
<tr
class=
"rowColor"
>
<td
class=
"colFirst"
><code>
private java.sql.PreparedStatement
</code></td>
<td
class=
"colLast"
><code><strong><a
href=
"../medical_unit/DBconnector_mu.html#preparedStatement"
>
preparedStatement
</a></strong></code>
</td>
</tr>
<tr
class=
"altColor"
>
<td
class=
"colFirst"
><code>
private java.sql.ResultSet
</code></td>
<td
class=
"colLast"
><code><strong><a
href=
"../medical_unit/DBconnector_mu.html#resultSet"
>
resultSet
</a></strong></code>
</td>
</tr>
</table>
</li>
</ul>
<!-- ======== CONSTRUCTOR SUMMARY ======== -->
<ul
class=
"blockList"
>
<li
class=
"blockList"
><a
name=
"constructor_summary"
>
<!-- -->
</a>
<h3>
Constructor Summary
</h3>
<table
class=
"overviewSummary"
border=
"0"
cellpadding=
"3"
cellspacing=
"0"
summary=
"Constructor Summary table, listing constructors, and an explanation"
>
<caption><span>
Constructors
</span><span
class=
"tabEnd"
>
</span></caption>
<tr>
<th
class=
"colOne"
scope=
"col"
>
Constructor and Description
</th>
</tr>
<tr
class=
"altColor"
>
<td
class=
"colOne"
><code><strong><a
href=
"../medical_unit/DBconnector_mu.html#DBconnector_mu()"
>
DBconnector_mu
</a></strong>
()
</code>
</td>
</tr>
</table>
</li>
</ul>
<!-- ========== METHOD SUMMARY =========== -->
<ul
class=
"blockList"
>
<li
class=
"blockList"
><a
name=
"method_summary"
>
<!-- -->
</a>
<h3>
Method Summary
</h3>
<table
class=
"overviewSummary"
border=
"0"
cellpadding=
"3"
cellspacing=
"0"
summary=
"Method Summary table, listing methods, and an explanation"
>
<caption><span>
Methods
</span><span
class=
"tabEnd"
>
</span></caption>
<tr>
<th
class=
"colFirst"
scope=
"col"
>
Modifier and Type
</th>
<th
class=
"colLast"
scope=
"col"
>
Method and Description
</th>
</tr>
<tr
class=
"altColor"
>
<td
class=
"colFirst"
><code>
private void
</code></td>
<td
class=
"colLast"
><code><strong><a
href=
"../medical_unit/DBconnector_mu.html#closeConnection()"
>
closeConnection
</a></strong>
()
</code>
<div
class=
"block"
>
This method close the connection to any database
</div>
</td>
</tr>
<tr
class=
"rowColor"
>
<td
class=
"colFirst"
><code>
java.util.ArrayList[]
</code></td>
<td
class=
"colLast"
><code><strong><a
href=
"../medical_unit/DBconnector_mu.html#getMarkers(int)"
>
getMarkers
</a></strong>
(int
ID_t)
</code>
</td>
</tr>
<tr
class=
"altColor"
>
<td
class=
"colFirst"
><code>
java.util.ArrayList
<
java.lang.Integer
>
</code></td>
<td
class=
"colLast"
><code><strong><a
href=
"../medical_unit/DBconnector_mu.html#getPatients()"
>
getPatients
</a></strong>
()
</code>
</td>
</tr>
<tr
class=
"rowColor"
>
<td
class=
"colFirst"
><code>
java.math.BigInteger
</code></td>
<td
class=
"colLast"
><code><strong><a
href=
"../medical_unit/DBconnector_mu.html#getPrivateKey(int)"
>
getPrivateKey
</a></strong>
(int
ID_p)
</code>
</td>
</tr>
<tr
class=
"altColor"
>
<td
class=
"colFirst"
><code>
java.math.BigInteger[]
</code></td>
<td
class=
"colLast"
><code><strong><a
href=
"../medical_unit/DBconnector_mu.html#getPublicKey(int)"
>
getPublicKey
</a></strong>
(int
ID_p)
</code>
</td>
</tr>
<tr
class=
"rowColor"
>
<td
class=
"colFirst"
><code>
int
</code></td>
<td
class=
"colLast"
><code><strong><a
href=
"../medical_unit/DBconnector_mu.html#getTestID(java.lang.String)"
>
getTestID
</a></strong>
(java.lang.String
desc)
</code>
</td>
</tr>
<tr
class=
"altColor"
>
<td
class=
"colFirst"
><code>
java.util.ArrayList[]
</code></td>
<td
class=
"colLast"
><code><strong><a
href=
"../medical_unit/DBconnector_mu.html#getTests()"
>
getTests
</a></strong>
()
</code>
</td>
</tr>
<tr
class=
"rowColor"
>
<td
class=
"colFirst"
><code>
void
</code></td>
<td
class=
"colLast"
><code><strong><a
href=
"../medical_unit/DBconnector_mu.html#insertKey(int, java.lang.String, boolean)"
>
insertKey
</a></strong>
(int
ID_p,
java.lang.String
key,
boolean
flag)
</code>
</td>
</tr>
<tr
class=
"altColor"
>
<td
class=
"colFirst"
><code>
void
</code></td>
<td
class=
"colLast"
><code><strong><a
href=
"../medical_unit/DBconnector_mu.html#insertMarker(java.lang.String, java.lang.String, java.lang.String, double)"
>
insertMarker
</a></strong>
(java.lang.String
rs_code,
java.lang.String
risk_alleles,
java.lang.String
gene,
double
maf)
</code>
</td>
</tr>
<tr
class=
"rowColor"
>
<td
class=
"colFirst"
><code>
void
</code></td>
<td
class=
"colLast"
><code><strong><a
href=
"../medical_unit/DBconnector_mu.html#insertPatient(int, java.lang.String, java.lang.String, java.lang.String, java.sql.Date)"
>
insertPatient
</a></strong>
(int
ID_p,
java.lang.String
name,
java.lang.String
last_name,
java.lang.String
sex,
java.sql.Date
birthdate)
</code>
</td>
</tr>
<tr
class=
"altColor"
>
<td
class=
"colFirst"
><code>
private void
</code></td>
<td
class=
"colLast"
><code><strong><a
href=
"../medical_unit/DBconnector_mu.html#openConnection()"
>
openConnection
</a></strong>
()
</code>
<div
class=
"block"
>
This method set up the connection to the PharmacoGenomics database
</div>
</td>
</tr>
</table>
<ul
class=
"blockList"
>
<li
class=
"blockList"
><a
name=
"methods_inherited_from_class_java.lang.Object"
>
<!-- -->
</a>
<h3>
Methods inherited from class
java.lang.Object
</h3>
<code>
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
</code></li>
</ul>
</li>
</ul>
</li>
</ul>
</div>
<div
class=
"details"
>
<ul
class=
"blockList"
>
<li
class=
"blockList"
>
<!-- ============ FIELD DETAIL =========== -->
<ul
class=
"blockList"
>
<li
class=
"blockList"
><a
name=
"field_detail"
>
<!-- -->
</a>
<h3>
Field Detail
</h3>
<a
name=
"connect"
>
<!-- -->
</a>
<ul
class=
"blockList"
>
<li
class=
"blockList"
>
<h4>
connect
</h4>
<pre>
private
java.sql.Connection connect
</pre>
</li>
</ul>
<a
name=
"preparedStatement"
>
<!-- -->
</a>
<ul
class=
"blockList"
>
<li
class=
"blockList"
>
<h4>
preparedStatement
</h4>
<pre>
private
java.sql.PreparedStatement preparedStatement
</pre>
</li>
</ul>
<a
name=
"resultSet"
>
<!-- -->
</a>
<ul
class=
"blockListLast"
>
<li
class=
"blockList"
>
<h4>
resultSet
</h4>
<pre>
private
java.sql.ResultSet resultSet
</pre>
</li>
</ul>
</li>
</ul>
<!-- ========= CONSTRUCTOR DETAIL ======== -->
<ul
class=
"blockList"
>
<li
class=
"blockList"
><a
name=
"constructor_detail"
>
<!-- -->
</a>
<h3>
Constructor Detail
</h3>
<a
name=
"DBconnector_mu()"
>
<!-- -->
</a>
<ul
class=
"blockListLast"
>
<li
class=
"blockList"
>
<h4>
DBconnector_mu
</h4>
<pre>
public
DBconnector_mu()
</pre>
</li>
</ul>
</li>
</ul>
<!-- ============ METHOD DETAIL ========== -->
<ul
class=
"blockList"
>
<li
class=
"blockList"
><a
name=
"method_detail"
>
<!-- -->
</a>
<h3>
Method Detail
</h3>
<a
name=
"getPatients()"
>
<!-- -->
</a>
<ul
class=
"blockList"
>
<li
class=
"blockList"
>
<h4>
getPatients
</h4>
<pre>
public
java.util.ArrayList
<
java.lang.Integer
>
getPatients()
throws java.sql.SQLException
</pre>
<dl><dt><span
class=
"strong"
>
Throws:
</span></dt>
<dd><code>
java.sql.SQLException
</code></dd></dl>
</li>
</ul>
<a
name=
"getTests()"
>
<!-- -->
</a>
<ul
class=
"blockList"
>
<li
class=
"blockList"
>
<h4>
getTests
</h4>
<pre>
public
java.util.ArrayList[]
getTests()
throws java.sql.SQLException
</pre>
<dl><dt><span
class=
"strong"
>
Throws:
</span></dt>
<dd><code>
java.sql.SQLException
</code></dd></dl>
</li>
</ul>
<a
name=
"getTestID(java.lang.String)"
>
<!-- -->
</a>
<ul
class=
"blockList"
>
<li
class=
"blockList"
>
<h4>
getTestID
</h4>
<pre>
public
int
getTestID(java.lang.String
desc)
throws java.sql.SQLException
</pre>
<dl><dt><span
class=
"strong"
>
Throws:
</span></dt>
<dd><code>
java.sql.SQLException
</code></dd></dl>
</li>
</ul>
<a
name=
"getMarkers(int)"
>
<!-- -->
</a>
<ul
class=
"blockList"
>
<li
class=
"blockList"
>
<h4>
getMarkers
</h4>
<pre>
public
java.util.ArrayList[]
getMarkers(int
ID_t)
throws java.sql.SQLException
</pre>
<dl><dt><span
class=
"strong"
>
Throws:
</span></dt>
<dd><code>
java.sql.SQLException
</code></dd></dl>
</li>
</ul>
<a
name=
"getPublicKey(int)"
>
<!-- -->
</a>
<ul
class=
"blockList"
>
<li
class=
"blockList"
>
<h4>
getPublicKey
</h4>
<pre>
public
java.math.BigInteger[]
getPublicKey(int
ID_p)
throws java.sql.SQLException
</pre>
<dl><dt><span
class=
"strong"
>
Throws:
</span></dt>
<dd><code>
java.sql.SQLException
</code></dd></dl>
</li>
</ul>
<a
name=
"getPrivateKey(int)"
>
<!-- -->
</a>
<ul
class=
"blockList"
>
<li
class=
"blockList"
>
<h4>
getPrivateKey
</h4>
<pre>
public
java.math.BigInteger
getPrivateKey(int
ID_p)
throws java.sql.SQLException
</pre>
<dl><dt><span
class=
"strong"
>
Throws:
</span></dt>
<dd><code>
java.sql.SQLException
</code></dd></dl>
</li>
</ul>
<a
name=
"insertMarker(java.lang.String, java.lang.String, java.lang.String, double)"
>
<!-- -->
</a>
<ul
class=
"blockList"
>
<li
class=
"blockList"
>
<h4>
insertMarker
</h4>
<pre>
public
void
insertMarker(java.lang.String
rs_code,
java.lang.String
risk_alleles,
java.lang.String
gene,
double
maf)
throws java.sql.SQLException
</pre>
<dl><dt><span
class=
"strong"
>
Throws:
</span></dt>
<dd><code>
java.sql.SQLException
</code></dd></dl>
</li>
</ul>
<a
name=
"insertKey(int, java.lang.String, boolean)"
>
<!-- -->
</a>
<ul
class=
"blockList"
>
<li
class=
"blockList"
>
<h4>
insertKey
</h4>
<pre>
public
void
insertKey(int
ID_p,
java.lang.String
key,
boolean
flag)
throws java.sql.SQLException
</pre>
<dl><dt><span
class=
"strong"
>
Throws:
</span></dt>
<dd><code>
java.sql.SQLException
</code></dd></dl>
</li>
</ul>
<a
name=
"insertPatient(int, java.lang.String, java.lang.String, java.lang.String, java.sql.Date)"
>
<!-- -->
</a>
<ul
class=
"blockList"
>
<li
class=
"blockList"
>
<h4>
insertPatient
</h4>
<pre>
public
void
insertPatient(int
ID_p,
java.lang.String
name,
java.lang.String
last_name,
java.lang.String
sex,
java.sql.Date
birthdate)
throws java.sql.SQLException
</pre>
<dl><dt><span
class=
"strong"
>
Throws:
</span></dt>
<dd><code>
java.sql.SQLException
</code></dd></dl>
</li>
</ul>
<a
name=
"openConnection()"
>
<!-- -->
</a>
<ul
class=
"blockList"
>
<li
class=
"blockList"
>
<h4>
openConnection
</h4>
<pre>
private
void
openConnection()
</pre>
<div
class=
"block"
>
This method set up the connection to the PharmacoGenomics database
</div>
</li>
</ul>
<a
name=
"closeConnection()"
>
<!-- -->
</a>
<ul
class=
"blockListLast"
>
<li
class=
"blockList"
>
<h4>
closeConnection
</h4>
<pre>
private
void
closeConnection()
</pre>
<div
class=
"block"
>
This method close the connection to any database
</div>
</li>
</ul>
</li>
</ul>
</li>
</ul>
</div>
</div>
<!-- ========= END OF CLASS DATA ========= -->
<!-- ======= START OF BOTTOM NAVBAR ====== -->
<div
class=
"bottomNav"
><a
name=
"navbar_bottom"
>
<!-- -->
</a><a
href=
"#skip-navbar_bottom"
title=
"Skip navigation links"
></a><a
name=
"navbar_bottom_firstrow"
>
<!-- -->
</a>
<ul
class=
"navList"
title=
"Navigation"
>
<li><a
href=
"../overview-summary.html"
>
Overview
</a></li>
<li><a
href=
"package-summary.html"
>
Package
</a></li>
<li
class=
"navBarCell1Rev"
>
Class
</li>
<li><a
href=
"class-use/DBconnector_mu.html"
>
Use
</a></li>
<li><a
href=
"package-tree.html"
>
Tree
</a></li>
<li><a
href=
"../deprecated-list.html"
>
Deprecated
</a></li>
<li><a
href=
"../index-files/index-1.html"
>
Index
</a></li>
<li><a
href=
"../help-doc.html"
>
Help
</a></li>
</ul>
</div>
<div
class=
"subNav"
>
<ul
class=
"navList"
>
<li>
Prev Class
</li>
<li><a
href=
"../medical_unit/GUI.html"
title=
"class in medical_unit"
><span
class=
"strong"
>
Next Class
</span></a></li>
</ul>
<ul
class=
"navList"
>
<li><a
href=
"../index.html?medical_unit/DBconnector_mu.html"
target=
"_top"
>
Frames
</a></li>
<li><a
href=
"DBconnector_mu.html"
target=
"_top"
>
No Frames
</a></li>
</ul>
<ul
class=
"navList"
id=
"allclasses_navbar_bottom"
>
<li><a
href=
"../allclasses-noframe.html"
>
All Classes
</a></li>
</ul>
<div>
<script
type=
"text/javascript"
>
<!--
allClassesLink
=
document
.
getElementById
(
"allclasses_navbar_bottom"
);
if
(
window
==
top
)
{
allClassesLink
.
style
.
display
=
"block"
;
}
else
{
allClassesLink
.
style
.
display
=
"none"
;
}
//-->
</script>
</div>
<div>
<ul
class=
"subNavList"
>
<li>
Summary:
</li>
<li>
Nested
|
</li>
<li><a
href=
"#field_summary"
>
Field
</a>
|
</li>
<li><a
href=
"#constructor_summary"
>
Constr
</a>
|
</li>
<li><a
href=
"#method_summary"
>
Method
</a></li>
</ul>
<ul
class=
"subNavList"
>
<li>
Detail:
</li>
<li><a
href=
"#field_detail"
>
Field
</a>
|
</li>
<li><a
href=
"#constructor_detail"
>
Constr
</a>
|
</li>
<li><a
href=
"#method_detail"
>
Method
</a></li>
</ul>
</div>
<a
name=
"skip-navbar_bottom"
>
<!-- -->
</a></div>
<!-- ======== END OF BOTTOM NAVBAR ======= -->
</body>
</html>
Event Timeline
Log In to Comment